DELETE FROM webpages_UsersInRoles
DELETE FROM webpages_Roles
DELETE FROM UserProfile
DELETE FROM webpages_Membership

SET IDENTITY_INSERT UserProfile ON
INSERT INTO UserProfile(UserId, UserName) VALUES(1, 'Admin')
INSERT INTO UserProfile(UserId, UserName) VALUES(2, 'Juan')
SET IDENTITY_INSERT UserProfile OFF

SET IDENTITY_INSERT webpages_Roles ON
INSERT INTO webpages_Roles (RoleId,RoleName) VALUES(1, 'Administrators')
INSERT INTO webpages_Roles (RoleId,RoleName) VALUES(2, 'Operator')
SET IDENTITY_INSERT webpages_Roles OFF

INSERT INTO webpages_UsersInRoles(UserId, RoleId) VALUES(1, 1)
INSERT INTO webpages_UsersInRoles(UserId, RoleId) VALUES(2, 2)

INSERT INTO webpages_Membership(
			[UserId]
           ,[CreateDate]
           ,[ConfirmationToken]
           ,[IsConfirmed]
           ,[LastPasswordFailureDate]
           ,[PasswordFailuresSinceLastSuccess]
           ,[Password]
           ,[PasswordChangedDate]
           ,[PasswordSalt]
           ,[PasswordVerificationToken]
           ,[PasswordVerificationTokenExpirationDate])
     VALUES(
			1
           ,GETDATE()
           ,NULL
           ,1
           ,NULL
           ,0
           ,'AFnZzpNZJE9JVmbedy6jFe5jGOo/7fcXX2CAJVnqfWY+ELHxvgwghbrpET5E4vOVQw=='
           ,GETDATE()
           ,''
           ,NULL
           ,NULL
           )

INSERT INTO webpages_Membership(
			[UserId]
           ,[CreateDate]
           ,[ConfirmationToken]
           ,[IsConfirmed]
           ,[LastPasswordFailureDate]
           ,[PasswordFailuresSinceLastSuccess]
           ,[Password]
           ,[PasswordChangedDate]
           ,[PasswordSalt]
           ,[PasswordVerificationToken]
           ,[PasswordVerificationTokenExpirationDate])
     VALUES(
			2
           ,GETDATE()
           ,NULL
           ,1
           ,NULL
           ,0
           ,'AFnZzpNZJE9JVmbedy6jFe5jGOo/7fcXX2CAJVnqfWY+ELHxvgwghbrpET5E4vOVQw=='
           ,GETDATE()
           ,''
           ,NULL
           ,NULL
           )

GO
